package com.personal.mapper;

import com.personal.pojo.TEquipment;
import com.personal.pojo.TEquipmentExample;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TEquipmentMapper {
    int countByExample(TEquipmentExample example);

    int deleteByExample(TEquipmentExample example);

    //彻底删除
    int deleteByPrimaryKey(Integer equipid);

    int insert(TEquipment record);

    //添加器材
    int insertSelective(TEquipment record);

    //查询所有器材信息,states=1
    List<TEquipment> selectAll();
    //查询所有器材信息,states=0
    List<TEquipment> selectAllDe();

    //根据id查询器材信息回显
    TEquipment selectByPrimaryKey(Integer equipid);

    int updateByExampleSelective(@Param("record") TEquipment record, @Param("example") TEquipmentExample example);

    int updateByExample(@Param("record") TEquipment record, @Param("example") TEquipmentExample example);

    //修改器材信息
    int updateByPrimaryKeySelective(TEquipment record);

    int updateByPrimaryKey(TEquipment record);
    //根据器材名,进购日期查询器材
    List selectByChuase(@Param("buyDate")String buyDate,@Param("equname")String equname);
    //暂时删除
    int delSt0(Integer equipid);
    //恢复
    int delSt1(Integer equipid);
}